Understanding the Simulated Chat Data Generated by the Scripts

Recall during Week 1 the latter part of the lecture on the Schema Overview where you learned about the simulated chat data model. This week you will be using a graph analytics approach to this simulated chat data as it relates to the Catch the Pink Flamingo game. Currently this chat data is purely numeric, no text. Analytically, it can still serve a useful purpose in revealing certain types of behaviors which can only be observed within a graph analytics context. Below is a brief description of these files to help you become familiar with our approach.

Attached is the PDF version of this document:

No Header Row

Please note that these files do not contain a header row since they do not need one for Neo4j. The parameters are explicitly identified in the Neo4j load scripts provided in the Hands-On instructions.

Simulation Specific Log Files

File: chat_create_team_chat.csv

ERD table: chat_create_team_chat

A line is added to this file when a player creates a new chat with their team.

Example:

userid, teamid, TeamChatSessionID, timestamp

559,48,6288,14567

876,15,6289,24244

1166,68,6290,65522

________________________________________________________________

File: chat_item_team_chat.csv

ERD table: chat_item_team_chat

Creates nodes labeled ChatItems. Column 0 is User id, column 1 is the TeamChatSession id, column 2 is the ChatItem id (i.e., the id property of the ChatItem node), column 3 is the timestamp for an edge labeled "CreateChat". Also create an edge labeled "PartOf" from the ChatItem node to the TeamChatSession node. This edge should also have a timeStamp property using the value from Column 3.

Example:

userid, teamchatsessionid, chatitemid, timestamp

1956,6299,6305,1464235803

2081,6296,6311,1464235823

1166,6290,6316,1464235546

________________________________________________________________

File: chat_join_team_chat.csv

ERD table: chat_join_team_chat

Creates an edge labeled "Joins" from User to TeamChatSession. The columns are the User id, TeamChatSession id and the timestamp of the Joins edge.

Example:

userid, TeamChatSessionID, teamstamp

559,6288,12345

876,6289,15468

1166,6290,15648

________________________________________________________________

File: chat_leave_team_chat.csv

ERD table: chat_leave_team_chat

Creates an edge labeled "Leaves" from User to TeamChatSession. The columns are the User id, TeamChatSession id and the timestamp of the Leaves edge.

Example:

userid, teamchatsessionid, timestamp

1244,6821,1464241204.0

1074,6838,1464243024.0

350,6777,1464246654.0

________________________________________________________________

File: chat_mention_team_chat.csv

ERD table: chat_mention_team_chat

Creates an edge labeled "Mentioned". Column 0 is the id of the ChatItem, column 1 is the id of the User, and column 2 is the timeStamp of the edge going from the chatItem to the User.

Example:

ChatItem, userid, timeStamp

6349,2508

6366,2491

6371,104

________________________________________________________________

File: chat_respond_team_chat.csv

ERD table: chat_respond_team_chat

A line is added to this file when player with chatid2 responds to a chat post by another player with chatid1.

Example:

chatid1, chatid2,timestamp

6326,6305,21564

6364,6326,54544

6371,6366,54567